/*
 Navicat MySQL Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 80021
 Source Host           : 127.0.0.1:3306
 Source Schema         : game

 Target Server Type    : MySQL
 Target Server Version : 80021
 File Encoding         : 65001

 Date: 18/09/2020 10:36:07
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for address
-- ----------------------------
DROP TABLE IF EXISTS `address`;
CREATE TABLE `address` (
  `addr_id` int NOT NULL AUTO_INCREMENT,
  `addr_dtl` varchar(255) NOT NULL,
  `addr_user_id` int NOT NULL,
  `addr_user_phone` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`addr_id`),
  KEY `addr_user_id` (`addr_user_id`),
  CONSTRAINT `addr_user_id` FOREIGN KEY (`addr_user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of address
-- ----------------------------
BEGIN;
INSERT INTO `address` VALUES (2, '浙江水利水电学院', 5, '15355417580');
INSERT INTO `address` VALUES (3, '厦门大学', 6, '15968849411');
INSERT INTO `address` VALUES (4, '浙江省 杭州市 下沙高教园区浙江水利水电学院', 5, '15988413544');
INSERT INTO `address` VALUES (5, '浙江省 台州市 杜桥镇码头', 5, '1576781164');
COMMIT;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `password` varchar(20) NOT NULL,
  `nickname` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of admin
-- ----------------------------
BEGIN;
INSERT INTO `admin` VALUES (2, 'root2', '11111', 'milk');
INSERT INTO `admin` VALUES (3, 'rwqr', '12', '42412421');
INSERT INTO `admin` VALUES (11, '5353', '532532', '235325');
COMMIT;

-- ----------------------------
-- Table structure for banner
-- ----------------------------
DROP TABLE IF EXISTS `banner`;
CREATE TABLE `banner` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ban_url` varchar(255) NOT NULL,
  `ban_name` varchar(40) NOT NULL,
  `ban_createtime` timestamp NOT NULL ON UPDATE CURRENT_TIMESTAMP,
  `ban_isshow` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 显示 0 隐藏',
  `goods_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of banner
-- ----------------------------
BEGIN;
INSERT INTO `banner` VALUES (45, '/admin/images/advertising/banner01.jpg', 'banner1', '2020-09-15 08:30:13', 0, 0);
INSERT INTO `banner` VALUES (46, '/admin/images/advertising/banner02.jpg', 'banner2', '2020-09-15 08:29:03', 1, 0);
INSERT INTO `banner` VALUES (47, '/admin/images/advertising/banner03.jpg', 'banner3', '2020-09-15 08:30:13', 0, 0);
INSERT INTO `banner` VALUES (48, '/admin/images/advertising/banner04.jpg', 'banner4', '2020-09-15 08:29:20', 1, 0);
INSERT INTO `banner` VALUES (49, '/admin/images/advertising/banner05.jpg', 'banner5', '2020-09-15 08:29:34', 1, 0);
INSERT INTO `banner` VALUES (50, '/admin/images/advertising/banner06.jpg', 'banner6', '2020-09-15 08:29:44', 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for cart
-- ----------------------------
DROP TABLE IF EXISTS `cart`;
CREATE TABLE `cart` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `goods_id` int NOT NULL,
  `goods_num` int DEFAULT '1',
  `status` tinyint DEFAULT '1' COMMENT '0 表示提交商品生成订单 1 购物车状态 -1 删除',
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `ischecked` tinyint DEFAULT '1' COMMENT '是否选中 1 选中 0 不选中',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of cart
-- ----------------------------
BEGIN;
INSERT INTO `cart` VALUES (34, 5, 9, 1, 0, '2020-09-17 14:37:43', '2020-09-17 14:37:43', 1);
INSERT INTO `cart` VALUES (35, 5, 8, 1, 0, '2020-09-17 14:37:44', '2020-09-17 14:37:44', 1);
INSERT INTO `cart` VALUES (36, 5, 1, 3, 0, '2020-09-17 14:45:00', '2020-09-17 14:45:00', 1);
INSERT INTO `cart` VALUES (37, 5, 9, 1, 0, '2020-09-17 14:45:01', '2020-09-17 14:45:01', 1);
INSERT INTO `cart` VALUES (38, 5, 18, 1, 0, '2020-09-17 14:53:55', '2020-09-17 14:53:55', 1);
INSERT INTO `cart` VALUES (39, 5, 11, 1, 0, '2020-09-17 14:54:16', '2020-09-17 14:54:16', 1);
INSERT INTO `cart` VALUES (40, 5, 30, 1, 0, '2020-09-17 15:46:40', '2020-09-17 15:46:40', 1);
INSERT INTO `cart` VALUES (41, 5, 10, 1, 0, '2020-09-17 19:52:21', '2020-09-17 19:52:21', 1);
INSERT INTO `cart` VALUES (42, 5, 12, 0, -1, '2020-09-17 22:56:23', '2020-09-17 22:56:23', 1);
INSERT INTO `cart` VALUES (43, 7, 8, 1, 0, '2020-09-18 08:34:59', '2020-09-18 08:34:59', 1);
INSERT INTO `cart` VALUES (44, 7, 11, 1, 0, '2020-09-18 08:35:07', '2020-09-18 08:35:07', 1);
INSERT INTO `cart` VALUES (45, 5, 19, 2, -1, '2020-09-18 10:12:06', '2020-09-18 10:12:17', 1);
INSERT INTO `cart` VALUES (46, 5, 20, 1, 0, '2020-09-18 10:14:35', '2020-09-18 10:14:35', 1);
INSERT INTO `cart` VALUES (47, 5, 30, 1, 0, '2020-09-18 10:14:36', '2020-09-18 10:14:36', 1);
COMMIT;

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` int NOT NULL AUTO_INCREMENT,
  `zh_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `en_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of category
-- ----------------------------
BEGIN;
INSERT INTO `category` VALUES (1, '动作游戏', 'action_game');
INSERT INTO `category` VALUES (2, '赛车竞速', 'race');
INSERT INTO `category` VALUES (3, '角色扮演', 'role_playing');
INSERT INTO `category` VALUES (4, '射击游戏', 'shooter_game');
INSERT INTO `category` VALUES (5, '模拟游戏', 'simulation');
INSERT INTO `category` VALUES (6, '战棋游戏', 'warchess_game');
COMMIT;

-- ----------------------------
-- Table structure for comments
-- ----------------------------
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `order_id` int NOT NULL,
  `grades` tinyint DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT NULL,
  `content` text,
  `status` tinyint NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of comments
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `id` int NOT NULL AUTO_INCREMENT,
  `goods_name` varchar(255) DEFAULT NULL,
  `goods_price` decimal(10,2) DEFAULT NULL,
  `goods_bill` varchar(255) DEFAULT NULL,
  `goods_label` varchar(255) DEFAULT NULL,
  `goods_categoryid` int NOT NULL,
  `goods_engname` varchar(255) DEFAULT NULL,
  `goods_tomarkettime` varchar(40) DEFAULT NULL,
  `goods_publishtime` varchar(40) DEFAULT NULL,
  `goods_studio` varchar(255) DEFAULT NULL,
  `goods_filesize` varchar(20) DEFAULT NULL,
  `goods_language` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `goods_runsystem` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `goods_describe` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `goods_buysum` int DEFAULT NULL,
  `goods_status` tinyint DEFAULT '1' COMMENT '1zhengchagn 0 jingyong -1 shanchu ',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `id` (`id`),
  KEY `goods_categoryid` (`goods_categoryid`),
  CONSTRAINT `goods_categoryid` FOREIGN KEY (`goods_categoryid`) REFERENCES `category` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of goods
-- ----------------------------
BEGIN;
INSERT INTO `goods` VALUES (1, '刺客信条3：重制版', 150.00, '/admin/images/goods/action_game/Assassins_Creed_3/Assassins_Creed_3.jpg', '动作游戏 潜入暗杀 暗杀 跑酷 第三人称视角', 1, 'Assassin\'s Creed 3: Remastered', '2019-03-29', '2019-03-28', 'Ubisoft', '36.0G', '繁体中文', 'Win7 x64/Win8 x64/Win10 x64', '《刺客信条3：重制版》游戏拥有更高分辨率，还有新的角色模型，新的光照渲染系统。育碧还改进了一些游戏机制，其中一些功能根据玩家的反馈进行修改或调整。除了游戏本体及全部扩展内容外，讲述了女刺客艾弗琳旅程的《刺客信条3：解放》完整重制也在其中。', 451, 1);
INSERT INTO `goods` VALUES (8, '死亡搁浅', 99.00, '/admin/images/goods/action_game/Death_Stranding/Death_Stranding.jpg', '动作游戏 剧情 恐怖 科幻 单人 动作', 1, 'Death Stranding', '2020-07-14', '2020-07-15', 'Kojima Production', '63.7G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '《死亡搁浅》是由Kojima Production制作、索尼发行的一款动作游戏，也是小岛秀夫成立新工作室后的第一部作品。游戏中的世界在经历了神秘的爆炸之后，引发了一系列超自然的事件，这些事件被称为“死亡搁浅”，导致整个地球变得面目全非。玩家将穿越在灾后的美国，尝试将支离破碎的世界重新“链接”在一起。', 32, 1);
INSERT INTO `goods` VALUES (9, '杀手5：赦免', 129.00, '/admin/images/goods/action_game/Hitman_Absolution/Hitman_Absolution.jpg', '动作游戏 潜入暗杀 暗杀 潜行 动作', 1, 'Hitman: Absolution', '2012-11-20', '2012-12-03', 'Io Interactive', '17.0G', '简体中文', 'Vista/Win7 x32/Win7 x64', '《杀手5：赦免》采用IO Interactive自主研发的冰川2（Glacier 2）引擎制作，游戏内的所有内容都是在引擎下实时进行反馈的，所有动作都是即时生成的。  　　新作主要场景发生在芝加哥，名为代号47的主角在本作中将更加灵活，更好控制。他将可以攀在悬崖边，还可以保持平衡，游戏融入了掩护系统，挟持人质的功能回归。', 45, 1);
INSERT INTO `goods` VALUES (10, '四海兄弟2：最终版', 149.00, '/admin/images/goods/action_game/Mafia_II_ Definitive/Mafia_II_ Definitive.jpg', '动作游戏 动作冒险 角色扮演 开放世界', 1, 'Mafia II Definitive', '2020-05-20', '2020-05-20', 'Hangar 13,D3T', '42.5G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '《四海兄弟2：最终版》是经典游戏《四海兄弟2》的4K高清重制版本，游戏中战争英雄维托·斯卡莱塔为了还清父亲欠下的债务与黑手党有了联系。他努力证明自己，不断犯下奖励更多、后果更严重的罪行，在黑道家族中的地位也越来越有分量。', 91, 1);
INSERT INTO `goods` VALUES (11, '看门狗2', 89.00, '/admin/images/goods/action_game/WatchDogs_2/WatchDogs_2.jpg', '动作游戏 光明会 黑客 开放世界 动作 跑酷', 1, 'Watch Dogs 2', '2016-11-29', '2017-01-19', 'Hangar 13,D3T', '22.2G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '    《看门狗2》是一款由Ubisoft制作并发行的动作冒险游戏。官方表示，为了保证新作的质量，他们希望《看门狗》的续作能够得到像《刺客信条2》那样的精雕细琢，让作品能够像前作那样充满新意时再开始续作的开发。  　　同时，他们还保证，《看门狗2》将会继承前作的一切优点，系统自由度更高，让玩家可以用自己想要尝试的方式探索世界，具体表现为游戏的叙事和角色部分减少，创造元素更丰富，给玩家的选择性也会更多。', 111, 1);
INSERT INTO `goods` VALUES (12, '尘埃4', 60.00, '/admin/images/goods/race/DiRT_4/DiRT_4.jpg', '竞速 模拟 体育 多人 驾驶 越野', 2, 'DiRT 4', '2017-06-10', '2017-06-09', 'Codemasters', '34.9G', '英文', 'Win7 x64/Win8 x64/Win10 x64', '《尘埃4》是经典越野赛车系列《尘埃》的正统续作，本系列游戏以火爆的越野赛车和更加贴近真实的天气及画面效果而吸引了众多的粉丝。', 541, 1);
INSERT INTO `goods` VALUES (13, 'F1 2020', 60.00, '/admin/images/goods/race/F1_2020/F1_2020.jpg', '竞速 模拟 体育 驾驶 拟真', 2, 'F1 2020', '2020-07-11', '2020-07-07', 'Codemasters', '32.8G', '英文', 'Win7 x64/Win8 x64/Win10 x64', '《F1 2020》是一款由Codemasters制作发行的赛车竞速游戏，本作为《F1》系列赛车游戏的正统续作。在游戏内容上与F1进行深度合作，为游戏打造专门的定制赛车。', 200, 1);
INSERT INTO `goods` VALUES (14, '极限竞速地平线3', 299.00, '/admin/images/goods/race/Forza_Horizon_3/Forza_Horizon_3.jpg', '竞速 3D 赛车', 2, 'Forza Horizon 3', '2016-09-27', '2016-09-22', 'Playground Games', '49.1G', '简体中文', 'Win10 x64', '《极限竞速：地平线3》是由Turn 10制作、微软发行的一款赛车竞速游戏，游戏地点设置在了南半球的澳大利亚，本作强调野外的驾驶体验，场景非常多样化，有草原、海滩、沙漠、城镇，车辆的选择也更多，从超跑到越野车，应有尽有。除了在开放世界中自由驾驶竞速，还能够欣赏沿途的美丽风景。本作的画面表现有巨大的提升，无论是车体建模还是赛车场景的设计，都足以用“养眼”来形容。此外，这也是继《极限竞速6》之后，第二款登陆PC平台的《极限竞速》系列游戏。', 51, 1);
INSERT INTO `goods` VALUES (15, '摩托GP17', 20.00, '/admin/images/goods/race/MotoGP_17/MotoGP_17.jpg', '竞速 体育 模拟 多人 3D', 2, 'MotoGP 17', '2017-06-15', '2017-06-15', 'Milestone', '10.0G', '英文', 'Win7 x64/Win8 x64/Win10 x64', '《摩托GP 17》是由Milestone制作的一款摩托类竞速游戏，本作将包括2017年所有车手、车队和赛道，以及全新的规则和红牛新秀杯赛事。游戏将首次达到60FPS，提供前所未有的游戏体验。', 200, 1);
INSERT INTO `goods` VALUES (16, '赛车计划2', 350.00, '/admin/images/goods/race/Project_CARS_2/Project_CARS_2.jpg', '竞速 驾驶 模拟 多人 虚拟现实', 2, 'Project CARS 2', '2017-09-22', '2017-09-22', 'Slightly Mad Studios', '45.1G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '《赛车计划2》是由Slightly Mad、Bandai Namco制作发行的一款竞速赛车游戏。相比于前作，本作游戏临场感全面提升！可进入自由无极限的飙速世界！新作采用「LiveTrack3.0」技术，可模拟实时天气变化及季节感，例如沙尘、下雪、大雨等都能忠实呈现。另外不同的天气条件也会导致赛道路面状况和轮胎的抓地力、物理磨损等产生差异，带给玩家最完美的竞速体验。', 300, 1);
INSERT INTO `goods` VALUES (17, '飙酷车神2', 241.00, '/admin/images/goods/race/The_Crew_2/The_Crew_2.jpg', '竞速 3D 开放世界 动作 多人 驾驶', 2, 'The Crew 2', '2018-06-26', '2018-06-29', 'Slightly Mad Studios', '24.0G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '《飙酷车神2》是由育碧制作并发行的一款赛车竞速类游戏。与前作相比，本作玩法更多、手感更佳、甚至连侧重的主题也有所不同。无论是水里游的快艇，还是天上飞的飞机都可以随时随地都可以手控地进行切换，玩家可以尽情享受自由驰骋的感觉。', 251, 1);
INSERT INTO `goods` VALUES (18, '辐射76', 160.00, '/admin/images/goods/role_playing/Fallout_76/Fallout_76.jpg', '角色扮演 末世 科幻 多人', 3, 'Fallout 76', '2018-11-14', '2018-11-14', 'Bethesda', '50.0G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '辐射76是一款大型多人在线角色扮演游戏，在这款辐射新作品中玩家将返回西弗吉尼亚，寻找大山深处的秘密。两大派系在这里不断争斗，掠夺者也在四处强取豪夺，废土故事又将展开。  《辐射76》的故事发生于76号避难所，该避难所的记录存在于钢铁兄弟会总部Citadel的电脑中，是17个受控制的避难所之一。这里可容纳有500人，计划在核战20年后开放。此外，该避难所还有一起外星人绑架事件的记录。', 467, 1);
INSERT INTO `goods` VALUES (19, '天命奇御', 35.00, '/admin/images/goods/role_playing/Fate_Seeker/Fate_Seeker.jpg', '角色扮演 国产 剑侠 3D', 3, 'Fate Seeker', '2018-08-08', '2018-08-07', '甲山林娱乐', '5.9G', '简体中文', 'Win7/Win8/Win10', '《天命奇御》是由甲山林娱乐自制研发以北宋为背景的3D武侠角色扮演游戏。玩家将扮演初入武林的少年穿梭幽境祕地、任意游走于多线故事中。游戏中玩家将面临武侠人生的挣扎抉择，战或降？杀或放？每个抉定都将触发更多爱恨纠葛的精彩奇遇。', 828, 1);
INSERT INTO `goods` VALUES (20, '最终幻想15', 299.00, '/admin/images/goods/role_playing/FinalFantasy_XV/FinalFantasy_XV.jpg', '角色扮演 奇幻 3D 沙盒 角色扮演 开放世界', 3, 'Final Fantasy XV', '2018-03-07', '2018-02-27', 'Square Enix', '20.0G', '繁体中文', 'Win7 x64/Win8 x64/Win10 x64', '《最终幻想15》是第三人称射击元素的动作角色扮演游戏，该游戏拥有广阔的环境和一个无缝的和可定制的战斗系统，为玩家提供了很大的自由。  　　游戏被设定在现代，但这个城市像国家Lucis主角Noctis冰雹从中世纪的国家所包围，否则只有先进的技术位置。这道鸿沟的原因是一个冷晶体发动了战争，最后Lucis持有。其他国家曾经有过自己的结晶，但失去了他们，由于持续不断的冲突。只是随着冷战结束和和平利用晶体的条约宣布，国家尼芙菲姆意外侵入Lucis，迫使Noctis和他的朋友们逃脱。在发动战争对国家索尔海姆，Tenebrae和Accordo，尼芙菲姆的力量征服最后剩余的晶体，但Noctis试图阻止他们前他们可以离开这个城市。', 13, 1);
INSERT INTO `goods` VALUES (21, '贪婪之秋', 49.00, '/admin/images/goods/role_playing/GreedFall/GreedFall.jpg', '角色扮演 奇幻 开放世界 动作', 3, 'GreedFall', '2019-09-10', '2019-09-10', 'Spiders', '19.0G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '《贪婪之秋》是一款由Spiders开发的角色扮演游戏。游戏的背景设定在带有一丝魔幻的色彩的17世纪，画面上有一股浓浓的巴洛克艺术风格。在游戏中玩家们将会前往一个新的岛屿开启自己的旅程，与玩家同行的还有其他的开拓者、佣兵和淘金者，但这块陌生的土地受到了魔法的眷顾，传言这背后拥有着大量早已被遗忘的秘密。  　　而随着玩家旅途的深入，一系列神秘的事件也随之展开，玩家自身则夹在入侵的开拓者和当地原住民之间，这些原住民受到了各种魔法生物的保护，这些魔法生物则是这片岛屿古老魔法的化身。', 158, 1);
INSERT INTO `goods` VALUES (22, '废土3', 99.00, '/admin/images/goods/role_playing/Wasteland3/Wasteland3.jpg', '角色扮演 3D 回合制 科幻 末世 策略', 3, 'Wasteland 3', '2020-08-28', '2020-08-28', 'inXile Entertainment', '23.0G', '英文', 'Win7 x64/Win8 x64/Win10 x64', '《废土3》是一款由inXile Entertainment开发的角色扮演游戏。游戏将引入系列初次加入的合作模式，让两位基友游玩战役模式，而且制作组还大幅优化战斗系统，加入更多载具系统与环境击杀动画，还包括游侠基地系统。  　　游戏设定为科罗拉多州某处寒冰大陆，作为众多探险者的成员抉择各种道德选择，而且采用开发商打造的《异域镇魂曲》新作加入的全新对话系统。', 68, 1);
INSERT INTO `goods` VALUES (23, '幽灵行动：断点', 222.00, '/admin/images/goods/shooter_game/Ghost_Recon_Breakpoint/Ghost_Recon_Breakpoint.jpg', '第三人称射击 科幻 战争', 4, 'Ghost Recon Breakpoint', '2020-08-28', '2019-10-04', '育碧', '40.8G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '《幽灵行动：断点》是由育碧制作发行的第三人称射击游戏系列《幽灵行动》新作。游戏支持单人或至多4名玩家合作游玩。玩家将探索最先进科技设施与野生自然环境共存的神秘岛屿“极光岛”。从数千个定制选项组合中创造出自己的完美“幽灵”，并且能在主线战役和PVP模式（发售时同步推出）中保留同样的游戏角色及游戏进度。', 99, 1);
INSERT INTO `goods` VALUES (24, '正当防卫4', 149.00, '/admin/images/goods/shooter_game/Just_Cause_4/Just_Cause_4.jpg', '第三人称射击 沙盒 动作 冒险 开放世界', 4, 'Just Cause 4', '2020-08-28', '2019-10-04', 'Avalanche Studios', '50.0G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '《正当防卫4》是由Avalanche Studios制作的第三人称射击游戏《正当防卫》系列正统续作。本作在承接前代作品鲜明特点的同时，也融入进了诸多新的元素，致力于带给大家全新的体验，至于酷炫刺激的战斗氛围绝对会让大家玩得不亦乐乎！', 113, 1);
INSERT INTO `goods` VALUES (25, '荒野大镖客：救赎2', 149.00, '/admin/images/goods/shooter_game/RedDead_Redemption2/RedDead_Redemption2.jpg', '第三人称射击 3D 西部风格 沙盒 多人', 4, 'Red Dead Redemption 2', '2019-11-05', '2019-10-31', 'Avalanche Studios', '109.0G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '时间是1899年的美国。执法人员开始追捕残存的亡命之徒帮派，旧西部时代的终章也随之展开。不愿投降或屈服者纷纷丧命。亚瑟·摩根和范德林帮派在西部城镇黑水镇的抢劫出了严重差错后，一行人不得不开始逃亡。遭到联邦探员和国内最出色赏金猎人追捕的他们为了生存，必须劫掠和战斗，跨越整个蛮荒的美国腹地。随着帮派的内部分裂愈演愈烈，亚瑟必须做出抉择：忠于自己的理想，还是一心忠于扶养他长大的帮派。', 113, 1);
INSERT INTO `goods` VALUES (26, '狙击精英V2重制版', 119.00, '/admin/images/goods/shooter_game/Sniper_Elite_V2_Remastered/Sniper_Elite_V2_Remastered.jpg', '第三人称射击 二战 潜行 射击 第三人称视角', 4, 'Red Dead Redemption 2', '2019-05-14', '2019-05-14', 'Rebellion', '10.5G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '《狙击精英V2重制版》是Rebellion制作发行的第三人称射击游戏。玩家将深入二战，操控美国特工，通过敌后暗杀大量纳粹目标，比如希特勒，还将探索V2火箭计划的秘密重制版支持4K、HDR与全新升级的画面与特效，全部DLC，以及可操控新角色，并附带拍照模式。', 69, 1);
INSERT INTO `goods` VALUES (27, '全境封锁2', 229.00, '/admin/images/goods/shooter_game/The_Division_2/The_Division_2.jpg', '第三人称射击 末世 改编', 4, 'The Division 2', '2019-03-15', '2019-03-11', 'Ubisoft Massive', '41.4G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '《全境封锁2》是由Ubisoft Massive制作，育碧安纳西，育碧上海等支持，根据著名军事小说家汤姆克兰西的同名小说改编游戏《全境封锁》系列续作。本作的游戏引擎更换为改进版雪花莲引擎，玩家还可以将一些游戏进度从一代转移到本作当中。', 331, 1);
INSERT INTO `goods` VALUES (28, '汽车修理工模拟2018', 45.00, '/admin/images/goods/simulation/Car_Mechanic_Simulator/Car_Mechanic_Simulator.jpg', '模拟 建造 驾驶 拟真 单人 竞速', 5, 'Car Mechanic Simulator 2018', '2017-07-28', '2017-08-01', 'Red Dot Games', '8.8G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '《汽车修理工模拟2018》是由Red Dot Games公司制作，由PlayWay S.A.发行的一款汽车修理工模拟竞速类游戏。《汽车修理工模拟2018》是“汽车修理工模拟”系列的最新作品，游戏除了保留该系列的经典玩法外，增加了更丰富的玩法，在画质方面也有了很大的提升，增加了更多的车型。', 120, 1);
INSERT INTO `goods` VALUES (29, '模拟狩猎', 30.00, '/admin/images/goods/simulation/Hunting_Simulator/Hunting_Simulator.jpg', '模拟 冒险 体育 狩猎', 5, 'Hunting Simulator', '2017-06-09', '2017-08-29', 'Red Dot Games', '5.1G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '《模拟狩猎》拥有单人和多人游戏模式，多种狩猎区域，还有数百种目标。该游戏采用虚拟引擎4开发，呈现了诸多闻名遐迩的狩猎地区，比如科罗拉多的群山，法国的橡木森林，还有阿拉斯加白雪皑皑的平原。 每个区域都拥有众多拥有人工智能行为的高仿真动物。', 51, 1);
INSERT INTO `goods` VALUES (30, '侏罗纪世界：进化', 67.00, '/admin/images/goods/simulation/Jurassic_World_Evolution/Jurassic_World_Evolution.jpg', '模拟 改编 恐龙 建造 沙盒 管理', 5, 'Jurassic World Evolution', '2018-06-12', '2018-06-13', 'Frontier Developments', '4.1G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '《侏罗纪世界：进化》是由Frontier Developments制作并发行的一款模拟经营类游戏。本作以“侏罗纪世界”为题材，玩家在游戏中可以建造属于自己的侏罗纪公园，培育恐龙物种，建造景点，而且还能够像电影中那样，让恐龙们搞些破坏。', 71, 1);
INSERT INTO `goods` VALUES (31, '微软飞行模拟', 77.00, '/admin/images/goods/simulation/Microsoft_Flight_Simulator/Microsoft_Flight_Simulator.jpg', '模拟 飞行', 5, 'Microsoft Flight Simulator', '2020-08-18', '2020-08-19', 'Microsoft', '200GB', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '《微软飞行模拟》是一款由Microsoft发行制作的模拟飞行类游戏，注重真实的飞行体验及令人惊叹的游戏画面与环境，专为飞行模拟类粉丝打造。通过重新运用微软的现有科技以及与相关产业机构和社区的通力合作，致力于为广大玩家提供一流的模拟飞行体验。', 50, 1);
INSERT INTO `goods` VALUES (32, '模拟人生4', 129.00, '/admin/images/goods/simulation/The_Sims_4/The_Sims_4.jpg', '模拟 3D', 5, 'The Sims 4', '2014-09-02', '2017-11-11', 'The Sim Studio', '200GB', '简体中文', 'XP/Vista/Win7 x32/Win7 x64/Win8 x32/Win8 x64', '《模拟人生4》资料片“猫与狗”，玩家可以在社区开设自己的宠物医院，关注流浪动物、带它们回家并为它们治疗疾病。游戏中的“创建宠物”功能使您能够将猫猫狗狗个性化，每一只都能拥有独特外貌与行为表现。', 666, 1);
INSERT INTO `goods` VALUES (33, '双点医院', 100.00, '/admin/images/goods/simulation/Two_Point_Hospital/Two_Point_Hospital.jpg', '模拟 管理 建造 单人 欢乐 搞笑', 5, 'Two Point Hospital', '2018-08-30', '2018-09-03', 'Two Point Studios', '1.6G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '《双点医院》是由之前开发过《主题医院》的原班团队“牛蛙”制作人组成的Two Point Interactive打造，并由世嘉发售的一款模拟经营类游戏。游戏的主旨是打造一流医院、治疗稀奇古怪的病症、管理各种棘手的医护人员，将一个简单的医疗机构规模扩大至整个双点县。', 21, 1);
INSERT INTO `goods` VALUES (34, '纪元1800', 129.00, '/admin/images/goods/warchess_game/Anno_1800/Anno_1800.jpg', '策略 沙盒 经济 单人 管理城市 营造', 6, 'Anno 1800', '2019-04-16', '2019-04-16', '育碧', '22.0G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '《纪元1800》是由育碧开发制作的《纪元》系列作品。本作中的帆船与蒸汽船仿佛会将我们带回了维多利亚时期，感受工业初起时的蒸汽浪漫。', 322, 1);
INSERT INTO `goods` VALUES (35, '文明6', 139.00, '/admin/images/goods/warchess_game/Civilization_VI/Civilization_VI.jpg', '策略 回合制 历史 多人', 6, 'Civilization VI', '2019-02-14', '2019-02-15', 'Firaxis', '9.8G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '《文明6：风云变幻》为玩家带来了一个生机勃勃的星球，在这里玩家会经历全新的和变幻多端的挑战。其中全新的游戏特征和系统包括环境系统，全新的工程项目以及不断消耗的自然资源，都让玩家身处在一个充满风险和机遇的世界去迎接未知挑战。此扩展包带来了外交胜利和世界议会，在这里玩家可以通过全球领袖投票带来的全球政策的变化来获取最终的胜利。科技和市政将会延伸到未来时间开启全新的可能性。除此以外，玩家们可在8个新文明与9位新领袖中进行选择，利用全新的单位、区域、奇观、建筑等内容称雄世界。', 269, 1);
INSERT INTO `goods` VALUES (36, '冰汽时代', 100.00, '/admin/images/goods/warchess_game/Frostpunk/Frostpunk.jpg', '策略 生存 城市营造 建造 蒸汽朋克', 6, 'Frostpunk', '2018-04-24', '2018-04-25', '11 Bit', '4.8G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '《冰汽时代》是由11 Bit工作室制作的一款蒸汽朋克风格的生存类游戏，开发者表示这款游戏着重展示“同情心和做决定”而不是“优选法和资源经营”。  　　游戏背景是一个危险的冰雪世界，蒸汽动力在这个世界中已经得到了广泛运用，用以驱散无处可避的致命严寒。玩家将在游戏中面临着严酷的道德困境，本作将会偏重策略和经营元素，但是也会是一个“情感驱使”的游戏。', 167, 1);
INSERT INTO `goods` VALUES (37, '这是我的战争', 59.00, '/admin/images/goods/warchess_game/This_War_of_Mine/This_War_of_Mine.jpg', '策略 现代战争 战争 独立游戏 生存', 6, 'This War of Mine', '2014-11-14', '2018-04-25', '11 Bit', '1.8G', '简体中文', 'XP/Vista/Win7 x32/Win7 x64/Win8 x32/Win8 x64', '《这是我的战争》别称《我的战争》、《吾之战争》、《我的这一战》。该作是由11 bit工作室所制作的黑暗求生游戏，与一般的战争游戏不同，玩家控制的并不是什么士兵，而是一群在战火中求生存的平民，开发商给出的理念是让玩家从另一个角度去看待战争。  　　可以说战争是游戏常用的故事背景，因为它能为玩家提供最直接的游戏目标：杀死敌人获胜。但历史告诉我们，任何战争，最大的受害者永远是平民。而市面上无数的军事游戏，几乎没有一款对这些无辜的平民的处境进行描绘，而本作将填补这一空白。', 34, 1);
INSERT INTO `goods` VALUES (38, '三国：全面战争', 99.00, '/admin/images/goods/warchess_game/Total_War_Three_Kingdoms/Total_War_Three_Kingdoms.jpg', '策略 三国 大型战场 剧情丰富 历史', 6, 'Total War:Three Kingdoms', '2019-05-23', '2019-05-23', 'Creative Assembly', '18.0G', '简体中文', 'Win7 x64/Win8 x64/Win10 x64', '《三国：全面战争》是由Creative Assembly开发并由世嘉发型的一款大型即时战略游戏，也是全面战争系列的最新作品。本作以古中国三国时期作为故事背景，凭借全面战争系列以往的大场面和恢弘大气的战场气氛，将三国时期那段枭雄与英雄辈出的时代增加了一抹不一样的色彩。', 299, 1);
COMMIT;

-- ----------------------------
-- Table structure for goods_adv_map
-- ----------------------------
DROP TABLE IF EXISTS `goods_adv_map`;
CREATE TABLE `goods_adv_map` (
  `id` int NOT NULL AUTO_INCREMENT,
  `goods_id` int NOT NULL,
  `imgUrl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `goods_id` (`goods_id`),
  CONSTRAINT `goods_id` FOREIGN KEY (`goods_id`) REFERENCES `goods` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of goods_adv_map
-- ----------------------------
BEGIN;
INSERT INTO `goods_adv_map` VALUES (9, 1, '/admin/images/goods/action_game/Assassins_Creed_3/Assassins_Creed_3_1.jpg');
INSERT INTO `goods_adv_map` VALUES (10, 1, '/admin/images/goods/action_game/Assassins_Creed_3/Assassins_Creed_3_2.jpg');
INSERT INTO `goods_adv_map` VALUES (11, 1, '/admin/images/goods/action_game/Assassins_Creed_3/Assassins_Creed_3_3.jpg');
INSERT INTO `goods_adv_map` VALUES (12, 1, '/admin/images/goods/action_game/Assassins_Creed_3/Assassins_Creed_3_4.jpg');
INSERT INTO `goods_adv_map` VALUES (13, 8, '/admin/images/goods/action_game/Death_Stranding/Death_Stranding_1.jpg');
INSERT INTO `goods_adv_map` VALUES (14, 8, '/admin/images/goods/action_game/Death_Stranding/Death_Stranding_2.jpg');
INSERT INTO `goods_adv_map` VALUES (15, 8, '/admin/images/goods/action_game/Death_Stranding/Death_Stranding_3.jpg');
INSERT INTO `goods_adv_map` VALUES (16, 8, '/admin/images/goods/action_game/Death_Stranding/Death_Stranding_4.jpg');
INSERT INTO `goods_adv_map` VALUES (17, 9, '/admin/images/goods/action_game/Hitman_Absolution/Hitman_Absolution_1.jpg');
INSERT INTO `goods_adv_map` VALUES (18, 9, '/admin/images/goods/action_game/Hitman_Absolution/Hitman_Absolution_2.jpg');
INSERT INTO `goods_adv_map` VALUES (19, 9, '/admin/images/goods/action_game/Hitman_Absolution/Hitman_Absolution_3.jpg');
INSERT INTO `goods_adv_map` VALUES (20, 9, '/admin/images/goods/action_game/Hitman_Absolution/Hitman_Absolution_4.jpg');
INSERT INTO `goods_adv_map` VALUES (21, 10, '/admin/images/goods/action_game/Mafia_II_ Definitive/Mafia_II_ Definitive_1.jpg');
INSERT INTO `goods_adv_map` VALUES (22, 10, '/admin/images/goods/action_game/Mafia_II_ Definitive/Mafia_II_ Definitive_2.jpg');
INSERT INTO `goods_adv_map` VALUES (23, 10, '/admin/images/goods/action_game/Mafia_II_ Definitive/Mafia_II_ Definitive_3.jpg');
INSERT INTO `goods_adv_map` VALUES (24, 10, '/admin/images/goods/action_game/Mafia_II_ Definitive/Mafia_II_ Definitive_4.jpg');
INSERT INTO `goods_adv_map` VALUES (25, 11, '/admin/images/goods/action_game/WatchDogs_2/WatchDogs_2_1.jpg');
INSERT INTO `goods_adv_map` VALUES (26, 11, '/admin/images/goods/action_game/WatchDogs_2/WatchDogs_2_2.jpg');
INSERT INTO `goods_adv_map` VALUES (27, 11, '/admin/images/goods/action_game/WatchDogs_2/WatchDogs_2_3.jpg');
INSERT INTO `goods_adv_map` VALUES (28, 11, '/admin/images/goods/action_game/WatchDogs_2/WatchDogs_2_4.jpg');
INSERT INTO `goods_adv_map` VALUES (29, 12, '/admin/images/goods/race/DiRT_4/DiRT_4_1.jpg');
INSERT INTO `goods_adv_map` VALUES (30, 12, '/admin/images/goods/race/DiRT_4/DiRT_4_2.jpg');
INSERT INTO `goods_adv_map` VALUES (31, 12, '/admin/images/goods/race/DiRT_4/DiRT_4_3.jpg');
INSERT INTO `goods_adv_map` VALUES (32, 12, '/admin/images/goods/race/DiRT_4/DiRT_4_4.jpg');
INSERT INTO `goods_adv_map` VALUES (34, 13, '/admin/images/goods/race/F1_2020/F1_2020_1.jpg');
INSERT INTO `goods_adv_map` VALUES (35, 13, '/admin/images/goods/race/F1_2020/F1_2020_2.jpg');
INSERT INTO `goods_adv_map` VALUES (36, 13, '/admin/images/goods/race/F1_2020/F1_2020_3.jpg');
INSERT INTO `goods_adv_map` VALUES (37, 13, '/admin/images/goods/race/F1_2020/F1_2020_4.jpg');
INSERT INTO `goods_adv_map` VALUES (38, 14, '/admin/images/goods/race/Forza_Horizon_3/Forza_Horizon_3_1.jpg');
INSERT INTO `goods_adv_map` VALUES (39, 14, '/admin/images/goods/race/Forza_Horizon_3/Forza_Horizon_3_2.jpg');
INSERT INTO `goods_adv_map` VALUES (40, 14, '/admin/images/goods/race/Forza_Horizon_3/Forza_Horizon_3_3.jpg');
INSERT INTO `goods_adv_map` VALUES (41, 14, '/admin/images/goods/race/Forza_Horizon_3/Forza_Horizon_3_4.jpg');
INSERT INTO `goods_adv_map` VALUES (42, 15, '/admin/images/goods/race/MotoGP_17/MotoGP_17_1.jpg');
INSERT INTO `goods_adv_map` VALUES (43, 15, '/admin/images/goods/race/MotoGP_17/MotoGP_17_2.jpg');
INSERT INTO `goods_adv_map` VALUES (44, 15, '/admin/images/goods/race/MotoGP_17/MotoGP_17_3.jpg');
INSERT INTO `goods_adv_map` VALUES (45, 15, '/admin/images/goods/race/MotoGP_17/MotoGP_17_4.jpg');
INSERT INTO `goods_adv_map` VALUES (46, 16, '/admin/images/goods/race/Project_CARS_2/Project_CARS_2_1.jpg');
INSERT INTO `goods_adv_map` VALUES (47, 16, '/admin/images/goods/race/Project_CARS_2/Project_CARS_2_2.jpg');
INSERT INTO `goods_adv_map` VALUES (48, 16, '/admin/images/goods/race/Project_CARS_2/Project_CARS_2_3.jpg');
INSERT INTO `goods_adv_map` VALUES (49, 16, '/admin/images/goods/race/Project_CARS_2/Project_CARS_2_4.jpg');
INSERT INTO `goods_adv_map` VALUES (50, 17, '/admin/images/goods/race/The_Crew_2/The_Crew_2_1.jpg');
INSERT INTO `goods_adv_map` VALUES (51, 17, '/admin/images/goods/race/The_Crew_2/The_Crew_2_2.jpg');
INSERT INTO `goods_adv_map` VALUES (52, 17, '/admin/images/goods/race/The_Crew_2/The_Crew_2_3.jpg');
INSERT INTO `goods_adv_map` VALUES (53, 17, '/admin/images/goods/race/The_Crew_2/The_Crew_2_4.jpg');
INSERT INTO `goods_adv_map` VALUES (54, 18, '/admin/images/goods/role_playing/Fallout_76/Fallout_76_1.jpg');
INSERT INTO `goods_adv_map` VALUES (55, 18, '/admin/images/goods/role_playing/Fallout_76/Fallout_76_2.jpg');
INSERT INTO `goods_adv_map` VALUES (56, 18, '/admin/images/goods/role_playing/Fallout_76/Fallout_76_3.jpg');
INSERT INTO `goods_adv_map` VALUES (57, 18, '/admin/images/goods/role_playing/Fallout_76/Fallout_76_4.jpg');
INSERT INTO `goods_adv_map` VALUES (58, 19, '/admin/images/goods/role_playing/Fate_Seeker/Fate_Seeker_1.jpg');
INSERT INTO `goods_adv_map` VALUES (62, 19, '/admin/images/goods/role_playing/Fate_Seeker/Fate_Seeker_2.jpg');
INSERT INTO `goods_adv_map` VALUES (63, 19, '/admin/images/goods/role_playing/Fate_Seeker/Fate_Seeker_3.jpg');
INSERT INTO `goods_adv_map` VALUES (64, 19, '/admin/images/goods/role_playing/Fate_Seeker/Fate_Seeker_4.jpg');
INSERT INTO `goods_adv_map` VALUES (65, 20, '/admin/images/goods/role_playing/FinalFantasy_XV/FinalFantasy_XV_1.jpg');
INSERT INTO `goods_adv_map` VALUES (66, 20, '/admin/images/goods/role_playing/FinalFantasy_XV/FinalFantasy_XV_2.jpg');
INSERT INTO `goods_adv_map` VALUES (67, 20, '/admin/images/goods/role_playing/FinalFantasy_XV/FinalFantasy_XV_3.jpg');
INSERT INTO `goods_adv_map` VALUES (68, 20, '/admin/images/goods/role_playing/FinalFantasy_XV/FinalFantasy_XV_4.jpg');
INSERT INTO `goods_adv_map` VALUES (69, 21, '/admin/images/goods/role_playing/GreedFall/GreedFall_1.jpg');
INSERT INTO `goods_adv_map` VALUES (70, 21, '/admin/images/goods/role_playing/GreedFall/GreedFall_2.jpg');
INSERT INTO `goods_adv_map` VALUES (71, 21, '/admin/images/goods/role_playing/GreedFall/GreedFall_3.jpg');
INSERT INTO `goods_adv_map` VALUES (72, 21, '/admin/images/goods/role_playing/GreedFall/GreedFall_4.jpg');
INSERT INTO `goods_adv_map` VALUES (73, 22, '/admin/images/goods/role_playing/Wasteland3/Wasteland3_1.jpg');
INSERT INTO `goods_adv_map` VALUES (74, 22, '/admin/images/goods/role_playing/Wasteland3/Wasteland3_2.jpg');
INSERT INTO `goods_adv_map` VALUES (75, 22, '/admin/images/goods/role_playing/Wasteland3/Wasteland3_3.jpg');
INSERT INTO `goods_adv_map` VALUES (76, 22, '/admin/images/goods/role_playing/Wasteland3/Wasteland3_4.jpg');
INSERT INTO `goods_adv_map` VALUES (77, 23, '/admin/images/goods/shooter_game/Ghost_Recon_Breakpoint/Ghost_Recon_Breakpoint_1.jpg');
INSERT INTO `goods_adv_map` VALUES (78, 23, '/admin/images/goods/shooter_game/Ghost_Recon_Breakpoint/Ghost_Recon_Breakpoint_2.jpg');
INSERT INTO `goods_adv_map` VALUES (79, 23, '/admin/images/goods/shooter_game/Ghost_Recon_Breakpoint/Ghost_Recon_Breakpoint_3.jpg');
INSERT INTO `goods_adv_map` VALUES (80, 23, '/admin/images/goods/shooter_game/Ghost_Recon_Breakpoint/Ghost_Recon_Breakpoint_4.jpg');
INSERT INTO `goods_adv_map` VALUES (81, 24, '/admin/images/goods/shooter_game/Just_Cause_4/Just_Cause_4_1.jpg');
INSERT INTO `goods_adv_map` VALUES (82, 24, '/admin/images/goods/shooter_game/Just_Cause_4/Just_Cause_4_2.jpg');
INSERT INTO `goods_adv_map` VALUES (83, 24, '/admin/images/goods/shooter_game/Just_Cause_4/Just_Cause_4_3.jpg');
INSERT INTO `goods_adv_map` VALUES (84, 24, '/admin/images/goods/shooter_game/Just_Cause_4/Just_Cause_4_4.jpg');
INSERT INTO `goods_adv_map` VALUES (85, 25, '/admin/images/goods/shooter_game/RedDead_Redemption2/RedDead_Redemption2_1.jpg');
INSERT INTO `goods_adv_map` VALUES (86, 25, '/admin/images/goods/shooter_game/RedDead_Redemption2/RedDead_Redemption2_2.jpg');
INSERT INTO `goods_adv_map` VALUES (87, 25, '/admin/images/goods/shooter_game/RedDead_Redemption2/RedDead_Redemption2_3.jpg');
INSERT INTO `goods_adv_map` VALUES (88, 25, '/admin/images/goods/shooter_game/RedDead_Redemption2/RedDead_Redemption2_4.jpg');
INSERT INTO `goods_adv_map` VALUES (89, 26, '/admin/images/goods/shooter_game/Sniper_Elite_V2_Remastered/Sniper_Elite_V2_Remastered_1.jpg');
INSERT INTO `goods_adv_map` VALUES (90, 26, '/admin/images/goods/shooter_game/Sniper_Elite_V2_Remastered/Sniper_Elite_V2_Remastered_2.jpg');
INSERT INTO `goods_adv_map` VALUES (91, 26, '/admin/images/goods/shooter_game/Sniper_Elite_V2_Remastered/Sniper_Elite_V2_Remastered_3.jpg');
INSERT INTO `goods_adv_map` VALUES (92, 26, '/admin/images/goods/shooter_game/Sniper_Elite_V2_Remastered/Sniper_Elite_V2_Remastered_4.jpg');
INSERT INTO `goods_adv_map` VALUES (93, 27, '/admin/images/goods/shooter_game/The_Division_2/The_Division_2_1.jpg');
INSERT INTO `goods_adv_map` VALUES (94, 27, '/admin/images/goods/shooter_game/The_Division_2/The_Division_2_2.jpg');
INSERT INTO `goods_adv_map` VALUES (95, 27, '/admin/images/goods/shooter_game/The_Division_2/The_Division_2_3.jpg');
INSERT INTO `goods_adv_map` VALUES (96, 27, '/admin/images/goods/shooter_game/The_Division_2/The_Division_2_4.jpg');
INSERT INTO `goods_adv_map` VALUES (97, 28, '/admin/images/goods/simulation/Car_Mechanic_Simulator/Car_Mechanic_Simulator_1.jpg');
INSERT INTO `goods_adv_map` VALUES (98, 28, '/admin/images/goods/simulation/Car_Mechanic_Simulator/Car_Mechanic_Simulator_2.jpg');
INSERT INTO `goods_adv_map` VALUES (99, 28, '/admin/images/goods/simulation/Car_Mechanic_Simulator/Car_Mechanic_Simulator_3.jpg');
INSERT INTO `goods_adv_map` VALUES (100, 28, '/admin/images/goods/simulation/Car_Mechanic_Simulator/Car_Mechanic_Simulator_4.jpg');
INSERT INTO `goods_adv_map` VALUES (101, 29, '/admin/images/goods/simulation/Hunting_Simulator/Hunting_Simulator_1.jpg');
INSERT INTO `goods_adv_map` VALUES (102, 29, '/admin/images/goods/simulation/Hunting_Simulator/Hunting_Simulator_2.jpg');
INSERT INTO `goods_adv_map` VALUES (103, 29, '/admin/images/goods/simulation/Hunting_Simulator/Hunting_Simulator_3.jpg');
INSERT INTO `goods_adv_map` VALUES (104, 29, '/admin/images/goods/simulation/Hunting_Simulator/Hunting_Simulator_4.jpg');
INSERT INTO `goods_adv_map` VALUES (105, 30, '/admin/images/goods/simulation/Jurassic_World_Evolution/Jurassic_World_Evolution_1.jpg');
INSERT INTO `goods_adv_map` VALUES (106, 30, '/admin/images/goods/simulation/Jurassic_World_Evolution/Jurassic_World_Evolution_2.jpg');
INSERT INTO `goods_adv_map` VALUES (107, 29, '/admin/images/goods/simulation/Hunting_Simulator/Jurassic_World_Evolution_3.jpg');
INSERT INTO `goods_adv_map` VALUES (108, 30, '/admin/images/goods/simulation/Jurassic_World_Evolution/Jurassic_World_Evolution_3.jpg');
INSERT INTO `goods_adv_map` VALUES (109, 30, '/admin/images/goods/simulation/Jurassic_World_Evolution/Jurassic_World_Evolution_4.jpg');
INSERT INTO `goods_adv_map` VALUES (110, 31, '/admin/images/goods/simulation/Microsoft_Flight_Simulator/Microsoft_Flight_Simulator_1.jpg');
INSERT INTO `goods_adv_map` VALUES (111, 31, '/admin/images/goods/simulation/Microsoft_Flight_Simulator/Microsoft_Flight_Simulator_2.jpg');
INSERT INTO `goods_adv_map` VALUES (112, 31, '/admin/images/goods/simulation/Microsoft_Flight_Simulator/Microsoft_Flight_Simulator_3.jpg');
INSERT INTO `goods_adv_map` VALUES (113, 31, '/admin/images/goods/simulation/Microsoft_Flight_Simulator/Microsoft_Flight_Simulator_4.jpg');
INSERT INTO `goods_adv_map` VALUES (114, 32, '/admin/images/goods/simulation/The_Sims_4/The_Sims_4_1.jpg');
INSERT INTO `goods_adv_map` VALUES (115, 32, '/admin/images/goods/simulation/The_Sims_4/The_Sims_4_2.jpg');
INSERT INTO `goods_adv_map` VALUES (116, 32, '/admin/images/goods/simulation/The_Sims_4/The_Sims_4_3.jpg');
INSERT INTO `goods_adv_map` VALUES (117, 32, '/admin/images/goods/simulation/The_Sims_4/The_Sims_4_4.jpg');
INSERT INTO `goods_adv_map` VALUES (118, 33, '/admin/images/goods/simulation/Two_Point_Hospital/Two_Point_Hospital_1.jpg');
INSERT INTO `goods_adv_map` VALUES (119, 33, '/admin/images/goods/simulation/Two_Point_Hospital/Two_Point_Hospital_2.jpg');
INSERT INTO `goods_adv_map` VALUES (120, 29, '/admin/images/goods/simulation/Hunting_Simulator/Two_Point_Hospital_3.jpg');
INSERT INTO `goods_adv_map` VALUES (121, 29, '/admin/images/goods/simulation/Hunting_Simulator/Two_Point_Hospital_4.jpg');
INSERT INTO `goods_adv_map` VALUES (122, 34, '/admin/images/goods/warchess_game/Anno_1800/Anno_1800_1.jpg');
INSERT INTO `goods_adv_map` VALUES (123, 34, '/admin/images/goods/warchess_game/Anno_1800/Anno_1800_2.jpg');
INSERT INTO `goods_adv_map` VALUES (124, 34, '/admin/images/goods/warchess_game/Anno_1800/Anno_1800_3.jpg');
INSERT INTO `goods_adv_map` VALUES (125, 34, '/admin/images/goods/warchess_game/Anno_1800/Anno_1800_4.jpg');
INSERT INTO `goods_adv_map` VALUES (126, 35, '/admin/images/goods/warchess_game/Civilization_VI/Civilization_VI_1.jpg');
INSERT INTO `goods_adv_map` VALUES (127, 35, '/admin/images/goods/warchess_game/Civilization_VI/Civilization_VI_2.jpg');
INSERT INTO `goods_adv_map` VALUES (128, 35, '/admin/images/goods/warchess_game/Civilization_VI/Civilization_VI_3.jpg');
INSERT INTO `goods_adv_map` VALUES (129, 35, '/admin/images/goods/warchess_game/Civilization_VI/Civilization_VI_4.jpg');
INSERT INTO `goods_adv_map` VALUES (130, 36, '/admin/images/goods/warchess_game/Frostpunk/Frostpunk_1.jpg');
INSERT INTO `goods_adv_map` VALUES (131, 36, '/admin/images/goods/warchess_game/Frostpunk/Frostpunk_2.jpg');
INSERT INTO `goods_adv_map` VALUES (132, 36, '/admin/images/goods/warchess_game/Frostpunk/Frostpunk_3.jpg');
INSERT INTO `goods_adv_map` VALUES (133, 36, '/admin/images/goods/warchess_game/Frostpunk/Frostpunk_4.jpg');
INSERT INTO `goods_adv_map` VALUES (134, 37, '/admin/images/goods/warchess_game/This_War_of_Mine/This_War_of_Mine_1.jpg');
INSERT INTO `goods_adv_map` VALUES (135, 37, '/admin/images/goods/warchess_game/This_War_of_Mine/This_War_of_Mine_2.jpg');
INSERT INTO `goods_adv_map` VALUES (136, 37, '/admin/images/goods/warchess_game/This_War_of_Mine/This_War_of_Mine_3.jpg');
INSERT INTO `goods_adv_map` VALUES (137, 37, '/admin/images/goods/warchess_game/This_War_of_Mine/This_War_of_Mine_4.jpg');
INSERT INTO `goods_adv_map` VALUES (138, 38, '/admin/images/goods/warchess_game/Total_War_Three_Kingdoms/Total_War_Three_Kingdoms_1.jpg');
INSERT INTO `goods_adv_map` VALUES (139, 38, '/admin/images/goods/warchess_game/Total_War_Three_Kingdoms/Total_War_Three_Kingdoms_2.jpg');
INSERT INTO `goods_adv_map` VALUES (140, 38, '/admin/images/goods/warchess_game/Total_War_Three_Kingdoms/Total_War_Three_Kingdoms_3.jpg');
INSERT INTO `goods_adv_map` VALUES (141, 38, '/admin/images/goods/warchess_game/Total_War_Three_Kingdoms/Total_War_Three_Kingdoms_4.jpg');
COMMIT;

-- ----------------------------
-- Table structure for order_goods
-- ----------------------------
DROP TABLE IF EXISTS `order_goods`;
CREATE TABLE `order_goods` (
  `id` int NOT NULL AUTO_INCREMENT,
  `order_id` int NOT NULL,
  `goods_id` int NOT NULL,
  `goods_num` int DEFAULT NULL,
  `goods_price` decimal(10,2) DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of order_goods
-- ----------------------------
BEGIN;
INSERT INTO `order_goods` VALUES (20, 13, 9, 3, 129.00, 1);
INSERT INTO `order_goods` VALUES (21, 13, 8, 1, 99.00, 1);
INSERT INTO `order_goods` VALUES (22, 14, 1, 1, 150.00, 1);
INSERT INTO `order_goods` VALUES (23, 14, 9, 1, 129.00, 1);
INSERT INTO `order_goods` VALUES (24, 15, 18, 1, 160.00, 1);
INSERT INTO `order_goods` VALUES (25, 16, 11, 1, 89.00, 1);
INSERT INTO `order_goods` VALUES (26, 17, 30, 1, 67.00, 1);
INSERT INTO `order_goods` VALUES (27, 18, 10, 1, 149.00, 1);
INSERT INTO `order_goods` VALUES (28, 19, 12, 1, 60.00, 1);
INSERT INTO `order_goods` VALUES (29, 20, 8, 1, 99.00, 1);
INSERT INTO `order_goods` VALUES (30, 20, 11, 1, 89.00, 1);
INSERT INTO `order_goods` VALUES (31, 21, 20, 1, 299.00, 1);
INSERT INTO `order_goods` VALUES (32, 21, 30, 1, 67.00, 1);
COMMIT;

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '订单id',
  `user_id` int NOT NULL,
  `pay_price` decimal(10,2) NOT NULL,
  `is_pay` tinyint(1) unsigned zerofill DEFAULT '0',
  `pay_time` timestamp NULL DEFAULT NULL,
  `is_ship` tinyint(1) unsigned zerofill DEFAULT '0',
  `ship_time` timestamp NULL DEFAULT NULL,
  `is_receipt` tinyint(1) unsigned zerofill DEFAULT '0',
  `receipt_time` timestamp NULL DEFAULT NULL,
  `status` tinyint DEFAULT '1' COMMENT '1 订单正常 0 订单完成 -1订单删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of orders
-- ----------------------------
BEGIN;
INSERT INTO `orders` VALUES (13, 5, 486.00, 0, NULL, 0, NULL, 0, NULL, -1, '2020-09-17 14:38:05', '2020-09-17 14:38:05');
INSERT INTO `orders` VALUES (14, 5, 579.00, 0, NULL, 0, NULL, 0, NULL, -1, '2020-09-17 14:45:05', '2020-09-17 14:45:05');
INSERT INTO `orders` VALUES (15, 5, 160.00, 0, NULL, 0, NULL, 0, NULL, -1, '2020-09-17 14:53:58', '2020-09-17 14:53:58');
INSERT INTO `orders` VALUES (16, 5, 89.00, 0, NULL, 0, NULL, 0, NULL, -1, '2020-09-17 14:54:18', '2020-09-17 14:54:18');
INSERT INTO `orders` VALUES (17, 5, 67.00, 1, '2020-09-17 19:07:40', 1, '2020-09-17 19:18:08', 1, '2020-09-17 19:42:58', 1, '2020-09-17 15:46:42', '2020-09-17 19:42:58');
INSERT INTO `orders` VALUES (18, 5, 149.00, 1, '2020-09-17 19:52:31', 1, '2020-09-17 19:54:37', 1, '2020-09-17 19:55:00', 1, '2020-09-17 19:52:24', '2020-09-17 19:55:00');
INSERT INTO `orders` VALUES (19, 5, 129.00, 1, '2020-09-18 10:15:36', 1, '2020-09-18 10:16:10', 1, '2020-09-18 10:16:30', 1, '2020-09-17 23:15:29', '2020-09-18 10:16:30');
INSERT INTO `orders` VALUES (20, 7, 188.00, 0, NULL, 0, NULL, 0, NULL, 1, '2020-09-18 08:35:10', '2020-09-18 08:35:10');
INSERT INTO `orders` VALUES (21, 5, 366.00, 0, NULL, 0, NULL, 0, NULL, 1, '2020-09-18 10:14:57', '2020-09-18 10:14:57');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_nick` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `user_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `user_session_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `user_sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `user_imgUrl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `user_balance` decimal(8,2) unsigned zerofill DEFAULT NULL,
  `user_vip_id` int DEFAULT '0',
  `user_status` tinyint DEFAULT '1',
  `user_phone` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (5, 'RELIFE', 'o0Ckd5Nb4kgWCoVMnFktcTd9T9dQ', '6Sy9dfbnaSmk/yzMhCdyjQ==', '男', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLlwIffuFE1ZaTADkdFbicK9Ybkia0E9NWYu9MYGKONxUHzY2v6ruibR2H0SvnAfovursPhKwDTok9pw/132', 000655.00, 0, 1, '1596884941111');
INSERT INTO `user` VALUES (6, '我', 'o0Ckd5KeOZrF8QwPkcyWZH5DbdFI', 'zylASvgJuaCca9gmvAksqQ==', 'none', 'https://thirdwx.qlogo.cn/mmopen/vi_32/pCUrja4Z78Oc5zF4JjfOCB9CYibGeZjw5IkRC8gjt74uP9oZl6tA06Ae0Pu8lXaPQaiaAKSmLMvpzJ0miblBFXx3w/132', 002000.00, 0, 1, NULL);
INSERT INTO `user` VALUES (7, '顾徵', 'o0Ckd5NjOptzzpm8pcVcQfqTjXQQ', 'XCtL4Z+LEP5TraJgmIh6zA==', '男', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTIemVrlsLGQyPufhUdIKXJ9GFnN218icZauDyMibaR1NcNlov9fZA9bQ2y0UXcg716yo0RfXwEiaibpOw/132', 001000.00, 0, 1, NULL);
COMMIT;

-- ----------------------------
-- Table structure for vip
-- ----------------------------
DROP TABLE IF EXISTS `vip`;
CREATE TABLE `vip` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '0 普通用户 1 白银会员 2 黄金会员 3 白金会员',
  `discount` decimal(4,2) NOT NULL COMMENT ' 1 0.9 0.8 0.7',
  `price` decimal(10,2) NOT NULL COMMENT '0 50  100 200',
  `days` int NOT NULL DEFAULT '30' COMMENT '30',
  `status` tinyint NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`,`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of vip
-- ----------------------------
BEGIN;
INSERT INTO `vip` VALUES (1, '普通客户', 1.00, 0.00, 88888, -1);
INSERT INTO `vip` VALUES (2, '白银客户', 0.90, 50.00, 30, 1);
COMMIT;

-- ----------------------------
-- Table structure for viprecord
-- ----------------------------
DROP TABLE IF EXISTS `viprecord`;
CREATE TABLE `viprecord` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `vip_id` int NOT NULL,
  `create_time` timestamp NOT NULL,
  `num` int NOT NULL,
  `remain_time` int NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of viprecord
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
